/*
 *  WsvJdbc - a JDBC driver for WSV (values separated by whatever) data files
 *  Copyright (C) 2004  Daniele Pes
 *
 *  This library is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU Lesser General Public
 *  License as published by the Free Software Foundation; either
 *  version 2.1 of the License, or (at your option) any later version.
 *
 *  This library is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *  Lesser General Public License for more details.
 *
 *  You should have received a copy of the GNU Lesser General Public
 *  License along with this library; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
 
package axs.jdbc.dataSpecification.supportedJavaTypes;

import java.sql.Timestamp;

import axs.jdbc.dataSourceConfiguration.TypeException;
import axs.jdbc.utils.DateUtils;


public class SqlTimeStampClass 
extends TypeClass {
	public Object fromString(String value) throws TypeException {
		try{
         if(value == null)
            return (Timestamp)null;
			value = value.trim();   	
			if(value.toUpperCase().equals("NULL") || value.equals(""))
				return (Timestamp)null;			
			return Timestamp.valueOf(value); // default format is yyyy-mm-dd hh:mm:ss.fffffffff
		}
		catch(Exception e){
			throw new TypeException("Unable to parse from String to Timestamp -> " + e.getMessage());
		}
	}
	
	public Object fromString(String value,
									 String dateFormat) 
	throws TypeException{
		try{
         if(value == null)
            return (Timestamp)null;
			value = value.trim();
			if(value.toUpperCase().equals("NULL"))
				return (Timestamp)null;		
			return (Timestamp)DateUtils.parse(value, dateFormat);
		 }
		 catch(Exception e){
			 throw new TypeException("Unable to parse from String to Timestamp -> " + e.getMessage());
		 }
	}			
}
